package com.hna.eking.iBatis;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.transaction.annotation.Transactional;
@Transactional
public interface TableItemInfoImp {
	@Select("select * from FileForTabList where Table_Name = #{TableName}")
	public List<TableItemInfoMapper> getByTableName(String TableName);
	
	@Insert("insert into FileForTabList values(#{TableName}, #{Column_Name},#{Column_Type},#{Column_Alias})")
	public int InsertTableItem(TableItemInfoMapper newTbLst);
	
	@Delete("delete from FileForTabList where Table_Name = #{TableName}")
	public int DeleteTableItem(String TableName);
}
